package com.isorf.mapper;

import com.isorf.pojo.ShoeSize;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ShoeSizeMapper {
    @Insert("insert into shoe_size(size_number, size_status, size_remark) values(#{sizeNumber}, #{sizeStatus}, #{sizeRemark})")
    int addShoeSize(ShoeSize shoeSize);

    @Delete("delete from shoe_size where size_id = #{sizeId}")
    int deleteShoeSize(int sizeId);

    @Update("update shoe_size set size_number = #{sizeNumber}, size_status = #{sizeStatus}, size_remark = #{sizeRemark} where size_id = #{sizeId}")
    int updateShoeSize(ShoeSize shoeSize);

    @Select("select * from shoe_size where size_id = #{sizeId}")
    ShoeSize getShoeSizeById(int sizeId);

    @Select("select * from shoe_size")
    List<ShoeSize> getAllShoeSizes();
} 